//
//  XXSQLiteOpe.h   v1.2
//  
//
//  Created by Huang Xiu Yong on 12-7-1.
//  Copyright (c) 2012年 Huang Xiu Yong. All rights reserved.
//
//  Email:rockhxy@gmail.com
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>

#define kSQLiteDomain           @"SQLite"

@interface XXSQLiteOpe : NSObject{

    sqlite3 * database;
    sqlite3_stmt *tempStmt;
}

@property (nonatomic,retain)NSString *filePath;


-(id)initWithFilePath:(NSString *)path;


//检查数据库文件是否存在

-(BOOL)checkDataBaseFile:(NSError **)error;


//增 删 改 查 操作

-(BOOL)handleData:(NSString *)sql parameter:(NSArray *)paraArray error:(NSError **)error;

-(BOOL)handleMoreData:(NSString *)sql parameter:(NSArray *)paraArray error:(NSError **)error;
//查询数据

-(NSArray *)queryData:(NSString *)sql error:(NSError **)error;


-(BOOL)begainHandMoreDataWith:(NSString *)sql;

-(BOOL)bindDataWithParaArray:(NSArray *)array index:(NSInteger)index;

-(void)endHandMoreData;

@end
